/*
CREATE TABLE "base_de_relation" (
  "sequence_nbr" text(19) NOT NULL,
  "list_code" text(255),
  "job_content" text(255),
  "groupid" text(11),
  "library_code" text(255),
  "library_name" text(255),
  "de_code_f" text(255),
  "de_name_f" text(255),
  "unit_f" text(255),
  "library_code_z" text(255),
  "library_code_relation" text(255),
  "relation_content" text(255),
  "de_code_z" text(255),
  "de_name_z" text(255),
  "unit_z" text(255),
  "quantity" text(255),
  PRIMARY KEY ("sequence_nbr")
);
*/

use rbatis::crud;
use serde::{Deserialize, Serialize};

#[derive(Debug, Serialize, Deserialize)]
pub struct BaseDeRelation {
    pub sequence_nbr: String,
    pub list_code: Option<String>,
    pub job_content: Option<String>,
    pub groupid: Option<String>,
    pub library_code: Option<String>,
    pub library_name: Option<String>,
    pub de_code_f: Option<String>,
    pub de_name_f: Option<String>,
    pub unit_f: Option<String>,
    pub library_code_z: Option<String>,
    pub library_code_relation: Option<String>,
    pub relation_content: Option<String>,
    pub de_code_z: Option<String>,
    pub de_name_z: Option<String>,
    pub unit_z: Option<String>,
    pub quantity: Option<String>,
}
crud!(BaseDeRelation {}, "base_de_relation");
